UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0i+1rX/+hN2TyWg2s7MCTiiSjmfXwJ4pbqzyVTihswY='
WHERE
key_id = 'fe08a1483ccb87f0e9c4f40464676719daf253f70def47a0a099e0e65fe4878e'
AND (
token = '0i+1rX/+hN2TyWg2s7MCTiiSjmfXwJ4pbqzyVTihswY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)