UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JzvxDfxGM4u44mT8AkVc5ESpqdcdvLoAj5ikorzx0rQ='
WHERE
key_id = '71588bdb12beab40d9e7da69e8364e1443a19afdc0c5b800a2183e916efdfa2a'
AND (
token = 'JzvxDfxGM4u44mT8AkVc5ESpqdcdvLoAj5ikorzx0rQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)