UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+yYmCWhuTwJkO47umItxa/48Ur9epTa1ItddzbK06nI='
WHERE
key_id = '7fb2e212a959a43b80c54bf78d8d7d339212b01c4f67b857f144943e8d3df2e1'
AND (
token = '+yYmCWhuTwJkO47umItxa/48Ur9epTa1ItddzbK06nI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)