UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'i1r71iC6Yj5YrnxMx8uFEVenRwbVJBTHl3tKheJeVY4='
WHERE
key_id = '07d4a4b1f4ccf56352c9212d4336e50c8d9b68f4278b7dffc6143d2f7b668c24'
AND (
token = 'i1r71iC6Yj5YrnxMx8uFEVenRwbVJBTHl3tKheJeVY4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)