UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5TdIaugmtffKOKrIny8UkL+AbyAKW9ZcxM9NO7jiNhw='
WHERE
key_id = 'd3ef66a1358b3e9f478edef5eefc458b974397d5b86c33ebcaf01591fe7dbdd1'
AND (
token = '5TdIaugmtffKOKrIny8UkL+AbyAKW9ZcxM9NO7jiNhw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)