UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JCW2ygsfSlyD97oAmfxBPCWU37j8N1cPUzXohiA4ag0='
WHERE
key_id = '9765040bedea63f9acbaa70ebdff62a5af4479070bff55f7a2efe9c8d96bd56a'
AND (
token = 'JCW2ygsfSlyD97oAmfxBPCWU37j8N1cPUzXohiA4ag0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)