UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k4oxV04yItxEdK4bnweDjuPkbV4vphpUYqiC9t7yPiA='
WHERE
key_id = 'a3ae0d29c11321f7251fcd9f793bdc6557ba8c03f868a3fcc27983f1baa6f331'
AND (
token = 'k4oxV04yItxEdK4bnweDjuPkbV4vphpUYqiC9t7yPiA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)