UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r+JXnsUo7rYbGrYB3pWDwYWBUcDHeXvuH8MKwnciPmg='
WHERE
key_id = 'd2fd3bafa435ffcecce152d26a529d4b25b7335fd9bf3d6d9a8074a764f2cb66'
AND (
token = 'r+JXnsUo7rYbGrYB3pWDwYWBUcDHeXvuH8MKwnciPmg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)