UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bcOpUC/p4l+0QNOi6+hWXyHeb2CmXaRS5UW0ocCCo3I='
WHERE
key_id = 'cd9f68e3190e665547dd723ceabdcb2e720e6e33d21b12f7d4498d3f64889d3c'
AND (
token = 'bcOpUC/p4l+0QNOi6+hWXyHeb2CmXaRS5UW0ocCCo3I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)