UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'phCMqkT0+Fyq+J2bl7a1r5vBa6ueYows/vHI+2vl+Xg='
WHERE
key_id = 'b21e23de711b2fc7ed62fbdf5958bb2bae12e7b1dc053be9c7c74c627b743b83'
AND (
token = 'phCMqkT0+Fyq+J2bl7a1r5vBa6ueYows/vHI+2vl+Xg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)