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