UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5Q8caF4qzO8XOdgY/c8doL48R22H8D249c3LPjEePCI='
WHERE
key_id = '9a5ab467e29a21905178ba62983e4ee0ac0c5fff08a5a7f0686ca639daf90f74'
AND (
token = '5Q8caF4qzO8XOdgY/c8doL48R22H8D249c3LPjEePCI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)