UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LCzP+k2xb475Dv7lFwaGi+rHodbxkgYVa0ce0Vu7CY0='
WHERE
key_id = 'a4d3522c4970c263668e1568fdd14459e49834a2f6f774cc240a695c6309613a'
AND (
token = 'LCzP+k2xb475Dv7lFwaGi+rHodbxkgYVa0ce0Vu7CY0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)