UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cBGyBrREH7NaCepcYY3Y0ZSZJ9bcx6ga7NK+PWA6/aE='
WHERE
key_id = 'd067e78625ed8a619fe996878b138d4188cd5994a2e89cbdc31b5b06eb94528a'
AND (
token = 'cBGyBrREH7NaCepcYY3Y0ZSZJ9bcx6ga7NK+PWA6/aE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)