UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xvPO1adlCSlkdxddUvXMcqNa/pfwBRjR34PtNk9T9ME='
WHERE
key_id = '4c06cd38c30dc523ea4995145b6cbd8a22bea4fb95c9f617e1f40e9ba7b168ee'
AND (
token = 'xvPO1adlCSlkdxddUvXMcqNa/pfwBRjR34PtNk9T9ME='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)