UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0adqFqZb95fp7BKgUQjscBOg1pNc9jAuVk8kiyz0jGA='
WHERE
key_id = '59d1cb0318b50d9e51d1d8f3841a8da0dc353c1a844034529f2bbee25df70991'
AND (
token = '0adqFqZb95fp7BKgUQjscBOg1pNc9jAuVk8kiyz0jGA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)