UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xyYsBnqH+4NHbDeztwaI1jUON+Of3f7v22CfvNHs+J0='
WHERE
key_id = '649e50938a43830832e9cbf24cf307d9aeb22d5043aa048a33271ce5434b8130'
AND (
token = 'xyYsBnqH+4NHbDeztwaI1jUON+Of3f7v22CfvNHs+J0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)