UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2TVZQIYT2VGdsil6MAfk+Ms8Nc8HbdxEEVEbtvxFOZU='
WHERE
key_id = '521855237538370527c47309fc46df8e7a79203d573fb372d87df11ed4ee5b16'
AND (
token = '2TVZQIYT2VGdsil6MAfk+Ms8Nc8HbdxEEVEbtvxFOZU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)