UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GX1aUOZXFyU/qZxHzKcRCRIZUUXJ5CaHFHv8cHXRT8M='
WHERE
key_id = 'bccbbe9634fca138ae184206ce2090e8d8b48186fe60e5d17cba6b1a9a6974a1'
AND (
token = 'GX1aUOZXFyU/qZxHzKcRCRIZUUXJ5CaHFHv8cHXRT8M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)