UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vbpaap10L9wKq8mjQVzWpEkEeJyK8NstlrkPUFwevpA='
WHERE
key_id = 'c86fbf4c7b0d2c3171a6ec03211dd7b5244294a66ec469dbc1afcf3e3d15fb71'
AND (
token = 'vbpaap10L9wKq8mjQVzWpEkEeJyK8NstlrkPUFwevpA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)