UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Lb8EWav2kO77+vLAHA0CkzPMyflhX8ae7GTXpemvrwo='
WHERE
key_id = '6278db1f6469233193d601a447e1bba3e24f9e4e354d877d25cad1f717cc199f'
AND (
token = 'Lb8EWav2kO77+vLAHA0CkzPMyflhX8ae7GTXpemvrwo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)