UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bMUuiM6lOisVLKe8ncRoapka76QSt9YJ80df071803c='
WHERE
key_id = '0b8e20ad1f4344f25da5d0520ed9790467303f9af7cd4f07987ca40aa35f6485'
AND (
token = 'bMUuiM6lOisVLKe8ncRoapka76QSt9YJ80df071803c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)