UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'caveAC6tboVOonJ7ph4u7wFklQHS9oIHRx/Up01bUME='
WHERE
key_id = '055e45b1de916e2803eb18c18242092f80e70e9014756a29bd5dab4f04df718e'
AND (
token = 'caveAC6tboVOonJ7ph4u7wFklQHS9oIHRx/Up01bUME='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)