UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'umlcJckEHjRRULuTyk0GKVvI62jwCmdhyowwQtWo+48='
WHERE
key_id = 'b407592f317e6a900e7a23647a4ab1844f391aa967d5461c63aa6f8e1e4d1606'
AND (
token = 'umlcJckEHjRRULuTyk0GKVvI62jwCmdhyowwQtWo+48='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)