UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xqF/FoxzV26v3cCdO1ho/IK0mFjLcCmunpiZ08hGifk='
WHERE
key_id = '4e0aa08b47163091300b05ca181c8153261a81df1853e0d9fbc9979ca3f6b8dd'
AND (
token = 'xqF/FoxzV26v3cCdO1ho/IK0mFjLcCmunpiZ08hGifk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)