UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zNGfESNhibgJCB7VsAkBemcjIWcROO0sYtq8HK+WAxc='
WHERE
key_id = 'a72cd671e86d921509fcf6f8435bad3d7390cfd47cf34c63871759fe1f68936d'
AND (
token = 'zNGfESNhibgJCB7VsAkBemcjIWcROO0sYtq8HK+WAxc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)