UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uGXTwZ0VET8dMAdjLGJOTRMUpAmVD3B0YgCi02+pYGI='
WHERE
key_id = '1afc377b5b45d7470ea5a0f4ff44f163a296153589b260168d471f4bf0b3d2c5'
AND (
token = 'uGXTwZ0VET8dMAdjLGJOTRMUpAmVD3B0YgCi02+pYGI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)