UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pjg7ttyVaF+NvR/hNeS3W9tCXTgwxebf2dvlXaMkjWw='
WHERE
key_id = '9d7659269ea61cd9f7cd78fa166834afab890e19e36338585ffa3e4ae42ad1e1'
AND (
token = 'pjg7ttyVaF+NvR/hNeS3W9tCXTgwxebf2dvlXaMkjWw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)