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