UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WB9Qev2yuTUbxje/oNI9pxd3Y1PfuLTG3mOEBK9SRSs='
WHERE
key_id = 'af6479079bb51c7a70ed6bc87f02a1a5dd0995c49b3c6ea8c75af68f71f3f6ff'
AND (
token = 'WB9Qev2yuTUbxje/oNI9pxd3Y1PfuLTG3mOEBK9SRSs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)