UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uA4rMhEVmLL1IQT33nHkGni6qifAExtiK/Eisq9eD/A='
WHERE
key_id = 'bf6d78299a2d90c3232ba971f3affac322a2fa583bafe15746c76016a85c00d9'
AND (
token = 'uA4rMhEVmLL1IQT33nHkGni6qifAExtiK/Eisq9eD/A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)