UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'c1bnz6g5miVMWylCvJy6HYyRm6xmd5w/a03SnhOE3Sc='
WHERE
key_id = 'a78093b5fa65426b9bb21a25b8b40593078b44304378afad9f4589a3fce95a89'
AND (
token = 'c1bnz6g5miVMWylCvJy6HYyRm6xmd5w/a03SnhOE3Sc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)